﻿CREATE TABLE [dbo].[Weather]
(
[rd_id] [int] NOT NULL,
[rd_dateTime] [datetime] NOT NULL,
[rd_temp] [decimal] (3, 1) NOT NULL,
[rd_humidity] [decimal] (4, 1) NOT NULL,
[rd_dewpoint] [decimal] (3, 1) NOT NULL,
[rd_windSpeed] [decimal] (3, 1) NOT NULL,
[rd_recentHighGust] [decimal] (3, 1) NOT NULL,
[rd_currentWindBearing] [int] NOT NULL,
[rd_currentRainfallRate] [decimal] (4, 1) NOT NULL,
[rd_rainfallToday] [decimal] (5, 1) NOT NULL,
[rd_pressure] [decimal] (5, 1) NOT NULL,
[rd_insideTemp] [decimal] (3, 1) NOT NULL,
[rd_insideHumidity] [decimal] (3, 1) NOT NULL,
[rd_currentGust] [decimal] (3, 1) NOT NULL
) ON [PRIMARY]


